/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80025
 Source Host           : localhost:3306
 Source Schema         : adb_express_management

 Target Server Type    : MySQL
 Target Server Version : 80025
 File Encoding         : 65001

 Date: 28/08/2021 19:50:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for address_center
-- ----------------------------
DROP TABLE IF EXISTS `address_center`;
CREATE TABLE `address_center` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `district` varchar(255) NOT NULL,
  `home_user_type` int NOT NULL,
  `landline` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `province` varchar(255) NOT NULL,
  `home_user_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKfuu8fy8y5294hqwybdlyc53ku` (`home_user_id`),
  CONSTRAINT `FKfuu8fy8y5294hqwybdlyc53ku` FOREIGN KEY (`home_user_id`) REFERENCES `home_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of address_center
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for aging_query
-- ----------------------------
DROP TABLE IF EXISTS `aging_query`;
CREATE TABLE `aging_query` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `destination` varchar(80) NOT NULL,
  `eta` int NOT NULL,
  `origin` varchar(80) NOT NULL,
  `price_per_kilogram` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of aging_query
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for branch_apply_for
-- ----------------------------
DROP TABLE IF EXISTS `branch_apply_for`;
CREATE TABLE `branch_apply_for` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `address` varchar(255) NOT NULL,
  `admin_name` varchar(255) NOT NULL,
  `branch_apply_for_status` int NOT NULL,
  `branch_name` varchar(255) NOT NULL,
  `branch_type` int NOT NULL,
  `id_card` varchar(255) NOT NULL,
  `longitude_and_latitude` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `office_address` varchar(255) NOT NULL,
  `query_phone` varchar(255) NOT NULL,
  `reject_reason` varchar(255) DEFAULT NULL,
  `home_user_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK6iexp4je22j26vd3mjo9w4dkj` (`home_user_id`),
  CONSTRAINT `FK6iexp4je22j26vd3mjo9w4dkj` FOREIGN KEY (`home_user_id`) REFERENCES `home_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of branch_apply_for
-- ----------------------------
BEGIN;
INSERT INTO `branch_apply_for` VALUES (2, '2022-02-04 16:24:28', '2022-02-04 16:24:47', '河北省/石家庄市/长安区', '石灵', 0, '石家庄网点', 1, '412725199809187845', '121.586021,31.371322', '13629788553', '合肥', '13523948615', NULL, 10);
INSERT INTO `branch_apply_for` VALUES (3, '2022-02-04 16:44:10', '2022-02-04 16:44:15', '北京/北京市/东城区', '郭英杰', 0, '北京网点', 0, '412725199809187845', '116.664706,39.916927', '13629788553', '北京', '13523948615', NULL, 10);
INSERT INTO `branch_apply_for` VALUES (4, '2022-02-04 16:45:00', '2022-02-04 16:45:07', '重庆/重庆市/万州区', '刘隆', 0, '重庆', 0, '412725199809187845', '114.402395,38.103449', '13629788553', '运输', '13523948615', NULL, 10);
INSERT INTO `branch_apply_for` VALUES (5, '2021-08-28 16:05:25', '2021-08-28 16:07:05', '北京/北京市/海淀区', '刘能', 0, '666', 0, '522328199809291234', '116.35885,40.029063', '18386849119', '紫金园', '18386849119', NULL, 13);
INSERT INTO `branch_apply_for` VALUES (6, '2021-08-28 18:56:06', '2021-08-28 18:56:06', '北京/北京市/东城区', '得实大厦', 0, '大大', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '湿答答', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (7, '2021-08-28 18:59:16', '2021-08-28 18:59:16', '安徽省/合肥市/瑶海区', '湿答答', 0, '大大', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '大师答', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (8, '2021-08-28 18:59:18', '2021-08-28 18:59:18', '安徽省/合肥市/瑶海区', '湿答答', 0, '大大', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '大师答', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (9, '2021-08-28 19:00:21', '2021-08-28 19:00:21', '安徽省/合肥市/瑶海区', '湿答答', 0, '大大', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '大师答', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (10, '2021-08-28 19:00:28', '2021-08-28 19:00:28', '安徽省/合肥市/瑶海区', '湿答答', 0, '大大', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '大师答', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (11, '2021-08-28 19:01:19', '2021-08-28 19:01:19', '安徽省/合肥市/瑶海区', '湿答答', 0, '大大', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '大师答', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (12, '2021-08-28 19:02:50', '2021-08-28 19:02:50', '安徽省/合肥市/瑶海区', '湿答答', 0, '大大', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '大师答', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (13, '2021-08-28 19:05:48', '2021-08-28 19:05:48', '安徽省/合肥市/瑶海区', '湿答答', 0, '大大', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '大师答', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (14, '2021-08-28 19:05:56', '2021-08-28 19:05:56', '安徽省/合肥市/瑶海区', '湿答答', 0, '大大', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '大师答', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (15, '2021-08-28 19:07:30', '2021-08-28 19:07:30', '安徽省/合肥市/瑶海区', '湿答答', 0, '大大', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '大师答', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (16, '2021-08-28 19:12:47', '2021-08-28 19:12:47', '安徽省/合肥市/瑶海区', '湿答答', 0, '大大', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '大师答', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (17, '2021-08-28 19:15:41', '2021-08-28 19:15:41', '福建省/宁德市/福鼎市', '啊啊啊', 0, '大大', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '大师答', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (18, '2021-08-28 19:17:58', '2021-08-28 19:17:58', '安徽省/宿州市/砀山县', '试试', 0, '试试', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '试试', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (19, '2021-08-28 19:21:05', '2021-08-28 19:21:05', '广西壮族自治区/钦州市/钦北区', '绅士手', 0, '大大', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '撒', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (20, '2021-08-28 19:31:55', '2021-08-28 19:31:55', '北京/北京市/宣武区', '都撒到', 0, '大师答', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '湿答答', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (21, '2021-08-28 19:37:11', '2021-08-28 19:37:35', '北京/北京市/石景山区', '清清浅浅', 0, '清清浅浅', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '无误', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (22, '2021-08-28 19:39:11', '2021-08-28 19:39:31', '安徽省/芜湖市/弋江区', '青蛙', 0, '请求', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '啊啊啊', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (23, '2021-08-28 19:41:51', '2021-08-28 19:41:51', '安徽省/芜湖市/弋江区', '都撒到', 1, '大大', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '收到', '18386849119', NULL, NULL);
INSERT INTO `branch_apply_for` VALUES (24, '2021-08-28 19:44:16', '2021-08-28 19:44:16', '安徽省/铜陵市/狮子山区', '最后', 0, '最牛', 0, '522328196903264124', '116.518677,39.978437', '18386849119', '大师答', '18386849119', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for buy_off
-- ----------------------------
DROP TABLE IF EXISTS `buy_off`;
CREATE TABLE `buy_off` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `operation` int DEFAULT NULL,
  `status` int DEFAULT NULL,
  `buy_off_express_mail_order_id` bigint DEFAULT NULL,
  `buy_off_user_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKimioie0138r4plx2aw0hdn7tg` (`buy_off_express_mail_order_id`),
  KEY `FK6dow4uqsx78tn0p6lwujxc1xe` (`buy_off_user_id`),
  CONSTRAINT `FK6dow4uqsx78tn0p6lwujxc1xe` FOREIGN KEY (`buy_off_user_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FKimioie0138r4plx2aw0hdn7tg` FOREIGN KEY (`buy_off_express_mail_order_id`) REFERENCES `express_mail_order` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of buy_off
-- ----------------------------
BEGIN;
INSERT INTO `buy_off` VALUES (1, '2022-02-04 16:13:49', '2022-02-04 16:13:49', 2, 0, 1, 38);
INSERT INTO `buy_off` VALUES (2, '2022-02-04 16:13:52', '2022-02-04 16:13:52', 2, 0, 2, 38);
INSERT INTO `buy_off` VALUES (3, '2022-02-04 16:14:02', '2022-02-04 16:14:02', 2, 0, 5, 38);
INSERT INTO `buy_off` VALUES (4, '2022-02-04 16:14:06', '2022-02-04 16:14:06', 2, 0, 6, 38);
INSERT INTO `buy_off` VALUES (5, '2022-02-04 16:22:20', '2022-02-04 16:22:20', 2, 0, 3, 38);
INSERT INTO `buy_off` VALUES (6, '2022-02-04 16:22:21', '2022-02-04 16:22:21', 2, 0, 4, 38);
INSERT INTO `buy_off` VALUES (7, '2022-02-04 16:26:59', '2022-02-04 16:26:59', 2, 0, 13, 39);
INSERT INTO `buy_off` VALUES (8, '2022-02-04 16:30:12', '2022-02-04 16:30:12', 2, 0, 25, 39);
INSERT INTO `buy_off` VALUES (9, '2022-02-04 16:49:43', '2022-02-04 16:50:39', 1, 1, 2, 39);
INSERT INTO `buy_off` VALUES (10, '2022-02-04 16:49:45', '2022-02-04 16:49:45', 2, 1, 1, 39);
INSERT INTO `buy_off` VALUES (11, '2022-02-04 16:49:49', '2022-02-04 16:50:41', 1, 1, 5, 39);
INSERT INTO `buy_off` VALUES (12, '2022-02-04 16:49:50', '2022-02-04 16:50:47', 1, 1, 6, 39);
INSERT INTO `buy_off` VALUES (13, '2022-02-04 16:49:54', '2022-02-04 16:50:50', 1, 1, 3, 39);
INSERT INTO `buy_off` VALUES (14, '2022-02-04 16:49:56', '2022-02-04 16:50:34', 1, 1, 4, 39);
INSERT INTO `buy_off` VALUES (15, '2022-02-04 16:50:34', '2022-02-04 16:51:26', 1, 2, 4, 40);
INSERT INTO `buy_off` VALUES (16, '2022-02-04 16:50:39', '2022-02-04 16:51:29', 1, 2, 2, 40);
INSERT INTO `buy_off` VALUES (17, '2022-02-04 16:50:41', '2022-02-04 16:50:41', 2, 2, 5, 40);
INSERT INTO `buy_off` VALUES (18, '2022-02-04 16:50:47', '2022-02-04 16:50:47', 2, 2, 6, 40);
INSERT INTO `buy_off` VALUES (19, '2022-02-04 16:50:50', '2022-02-04 16:50:50', 2, 2, 3, 40);
INSERT INTO `buy_off` VALUES (20, '2022-02-04 16:51:25', '2022-02-04 16:51:25', 2, 3, 4, 40);
INSERT INTO `buy_off` VALUES (21, '2022-02-04 16:51:28', '2022-02-04 16:51:28', 2, 3, 2, 40);
INSERT INTO `buy_off` VALUES (22, '2022-02-04 17:30:32', '2022-02-04 17:30:32', 2, 0, 26, 39);
INSERT INTO `buy_off` VALUES (23, '2022-02-04 18:09:51', '2022-02-04 18:09:51', 2, 0, 28, 39);
INSERT INTO `buy_off` VALUES (24, '2022-02-04 18:09:56', '2022-02-04 18:09:56', 2, 0, 27, 39);
INSERT INTO `buy_off` VALUES (25, '2022-02-04 18:13:17', '2022-02-04 18:14:41', 1, 1, 28, 46);
INSERT INTO `buy_off` VALUES (26, '2022-02-04 18:13:19', '2022-02-04 18:14:45', 1, 1, 27, 46);
INSERT INTO `buy_off` VALUES (27, '2022-02-04 18:14:41', '2022-02-04 18:15:11', 1, 2, 28, 47);
INSERT INTO `buy_off` VALUES (28, '2022-02-04 18:14:45', '2022-02-04 18:15:14', 1, 2, 27, 47);
INSERT INTO `buy_off` VALUES (29, '2022-02-04 18:15:10', '2022-02-04 18:15:10', 2, 3, 28, 47);
INSERT INTO `buy_off` VALUES (30, '2022-02-04 18:15:13', '2022-02-04 18:15:13', 2, 3, 27, 47);
COMMIT;

-- ----------------------------
-- Table structure for complaint
-- ----------------------------
DROP TABLE IF EXISTS `complaint`;
CREATE TABLE `complaint` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `content` varchar(255) DEFAULT NULL,
  `home_user_type` int DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` int DEFAULT NULL,
  `waybill_number` varchar(255) DEFAULT NULL,
  `home_user_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKarrgd24tdl9svemrou8364lkq` (`home_user_id`),
  CONSTRAINT `FKarrgd24tdl9svemrou8364lkq` FOREIGN KEY (`home_user_id`) REFERENCES `home_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of complaint
-- ----------------------------
BEGIN;
INSERT INTO `complaint` VALUES (1, '2022-02-04 16:54:12', '2022-02-04 16:54:12', '2022246990221021', 0, '13629788553', '王玲', 0, '2022246990221021', 10);
INSERT INTO `complaint` VALUES (2, '2022-02-04 16:54:44', '2022-02-04 16:54:44', '2022246991824A64', 1, '13725836914', '李虎', 0, '2022246991824A64', 10);
INSERT INTO `complaint` VALUES (3, '2022-02-04 16:55:09', '2022-02-04 16:55:09', '202224699RJXLR5S', 0, '13725836913', '郭华', 0, '202224699RJXLR5S', 10);
INSERT INTO `complaint` VALUES (4, '2022-02-04 16:55:54', '2022-02-04 16:55:54', '202224802FLLH7B8', 0, '13629788553', '田风', 0, '202224802FLLH7B8', 10);
COMMIT;

-- ----------------------------
-- Table structure for database_bak
-- ----------------------------
DROP TABLE IF EXISTS `database_bak`;
CREATE TABLE `database_bak` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `filename` varchar(32) NOT NULL,
  `filepath` varchar(128) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of database_bak
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for express_mail_order
-- ----------------------------
DROP TABLE IF EXISTS `express_mail_order`;
CREATE TABLE `express_mail_order` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `item_type` varchar(70) NOT NULL,
  `item_weight` double NOT NULL,
  `order_status` int DEFAULT NULL,
  `payment_method` int NOT NULL,
  `pick_up_time` datetime DEFAULT NULL,
  `recipients_address` varchar(70) NOT NULL,
  `recipients_full_address` varchar(30) NOT NULL,
  `recipients_landline_number` varchar(18) DEFAULT NULL,
  `recipients_mobile` varchar(12) DEFAULT NULL,
  `recipients_name` varchar(20) NOT NULL,
  `remark` varchar(266) DEFAULT NULL,
  `send_address` varchar(70) NOT NULL,
  `send_full_address` varchar(30) NOT NULL,
  `sender_email` varchar(80) NOT NULL,
  `sender_landline_number` varchar(18) DEFAULT NULL,
  `sender_mobile` varchar(12) DEFAULT NULL,
  `sender_name` varchar(20) NOT NULL,
  `waybill_number` varchar(30) NOT NULL,
  `home_user_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_em409oyw68ahw9brkvfkse4yx` (`waybill_number`),
  KEY `FK6wynqekkig7xakds1shv9r5c0` (`home_user_id`),
  CONSTRAINT `FK6wynqekkig7xakds1shv9r5c0` FOREIGN KEY (`home_user_id`) REFERENCES `home_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of express_mail_order
-- ----------------------------
BEGIN;
INSERT INTO `express_mail_order` VALUES (1, '2022-02-04 16:07:07', '2022-02-04 16:49:45', '食品,', 25, 5, 0, NULL, '北京', '北京/北京市/东城区', '0395-8451274', '13725836914', '王玲', '请带上文件夹', '安徽省', '安徽省/合肥市/包河区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '202202040083dbde6', 10);
INSERT INTO `express_mail_order` VALUES (2, '2022-02-04 16:13:36', '2022-02-04 16:51:29', '生活用品', 45, 6, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470251', '华玲珑', '123', '安徽省', '安徽省/合肥市/包河区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '2022248022101110', 10);
INSERT INTO `express_mail_order` VALUES (3, '2022-02-04 16:13:36', '2022-02-04 16:49:54', '数码产品', 12, 5, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470252', '王龙', '', '安徽省', '安徽省/合肥市/包河区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '20222480296552CC', 10);
INSERT INTO `express_mail_order` VALUES (4, '2022-02-04 16:13:36', '2022-02-04 16:51:26', '生活用品', 45, 6, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470254', '冯毅夫', '', '安徽省', '安徽省/合肥市/包河区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '202224802FLLH7B8', 10);
INSERT INTO `express_mail_order` VALUES (5, '2022-02-04 16:13:36', '2022-02-04 16:49:49', '生活用品', 45, 5, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470255', '千玲珑', '', '安徽省', '安徽省/合肥市/包河区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '202224802DCBLI0V', 10);
INSERT INTO `express_mail_order` VALUES (6, '2022-02-04 16:13:36', '2022-02-04 16:49:50', '生活用品', 12, 5, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470256', '王文凯', '', '安徽省', '安徽省/合肥市/包河区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '202224802aCGFVNW', 10);
INSERT INTO `express_mail_order` VALUES (7, '2022-02-04 16:13:36', '2022-02-04 16:13:36', '生活用品', 11, 0, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470257', '绳温', '123', '安徽省', '安徽省/合肥市/包河区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '202224802aJALmHN', 10);
INSERT INTO `express_mail_order` VALUES (8, '2022-02-04 16:13:36', '2022-02-04 16:13:36', '数码产品', 41, 0, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470258', '鞠士龙', '', '安徽省', '安徽省/合肥市/包河区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '202224802DV0IE6G', 10);
INSERT INTO `express_mail_order` VALUES (9, '2022-02-04 16:13:36', '2022-02-04 16:13:36', '生活用品', 13, 0, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470259', '王文', '', '安徽省', '安徽省/合肥市/包河区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '202224802tqWmzS6', 10);
INSERT INTO `express_mail_order` VALUES (10, '2022-02-04 16:13:36', '2022-02-04 16:13:36', '生活用品', 31, 0, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470260', '郭恒', '', '安徽省', '安徽省/合肥市/包河区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '202224802xrUL', 10);
INSERT INTO `express_mail_order` VALUES (11, '2022-02-04 16:13:36', '2022-02-04 16:13:36', '生活用品', 12, 0, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470261', '刘雅', '', '安徽省', '安徽省/合肥市/包河区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '202224802rK4Cp', 10);
INSERT INTO `express_mail_order` VALUES (12, '2022-02-04 16:13:36', '2022-02-04 16:13:36', '生活用品', 23, 0, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470262', '王燕', '', '安徽省', '安徽省/合肥市/包河区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '202224802zRUw1', 10);
INSERT INTO `express_mail_order` VALUES (13, '2022-02-04 16:25:40', '2022-02-04 16:59:30', '生活用品,', 1, 2, 0, NULL, '北京', '北京/北京市/东城区', '0395-8451274', '13725836914', '王玲', '1234', '安徽省', '河北省/石家庄市/长安区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '202202044709968cc', 10);
INSERT INTO `express_mail_order` VALUES (14, '2022-02-04 16:26:23', '2022-02-04 16:26:23', '生活用品', 45, 0, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470251', '华玲珑', '123', '安徽省', '河北省/石家庄市/长安区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '2022246990221021', 10);
INSERT INTO `express_mail_order` VALUES (15, '2022-02-04 16:26:23', '2022-02-04 16:26:23', '数码产品', 12, 0, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470252', '王龙', '', '安徽省', '河北省/石家庄市/长安区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '2022246991824A64', 10);
INSERT INTO `express_mail_order` VALUES (16, '2022-02-04 16:26:23', '2022-02-04 16:26:23', '生活用品', 45, 0, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470254', '冯毅夫', '', '安徽省', '河北省/石家庄市/长安区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '2022246992GJ7FJJ', 10);
INSERT INTO `express_mail_order` VALUES (17, '2022-02-04 16:26:23', '2022-02-04 16:26:23', '生活用品', 45, 0, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470255', '千玲珑', '', '安徽省', '河北省/石家庄市/长安区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '2022246998RRUGON', 10);
INSERT INTO `express_mail_order` VALUES (18, '2022-02-04 16:26:23', '2022-02-04 16:26:23', '生活用品', 12, 0, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470256', '王文凯', '', '安徽省', '河北省/石家庄市/长安区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '202224699RJXLR5S', 10);
INSERT INTO `express_mail_order` VALUES (19, '2022-02-04 16:26:23', '2022-02-04 16:26:23', '生活用品', 11, 0, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470257', '绳温', '123', '安徽省', '河北省/石家庄市/长安区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '2022246997FhDbG9', 10);
INSERT INTO `express_mail_order` VALUES (20, '2022-02-04 16:26:23', '2022-02-04 16:26:23', '数码产品', 41, 0, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470258', '鞠士龙', '', '安徽省', '河北省/石家庄市/长安区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '212124699hIJY6um', 10);
INSERT INTO `express_mail_order` VALUES (21, '2022-02-04 16:26:23', '2022-02-04 16:26:23', '生活用品', 13, 0, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470259', '王文', '', '安徽省', '河北省/石家庄市/长安区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '2121246998bTcKjv', 10);
INSERT INTO `express_mail_order` VALUES (22, '2022-02-04 16:26:23', '2022-02-04 16:26:23', '生活用品', 31, 0, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470260', '郭恒', '', '安徽省', '河北省/石家庄市/长安区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '212124699zLUfWA', 10);
INSERT INTO `express_mail_order` VALUES (23, '2022-02-04 16:26:23', '2022-02-04 16:26:23', '生活用品', 12, 0, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470261', '刘雅', '', '安徽省', '河北省/石家庄市/长安区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '2121246992GJQ66', 10);
INSERT INTO `express_mail_order` VALUES (24, '2022-02-04 16:26:23', '2022-02-04 16:26:23', '生活用品', 23, 0, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470262', '王燕', '', '安徽省', '河北省/石家庄市/长安区', '13523948375@163.com', '0395-8451274', '13629788553', '刘超', '212124699nQZWQ', 10);
INSERT INTO `express_mail_order` VALUES (25, '2022-02-04 16:29:52', '2022-02-04 16:30:13', '食品,', 1, 1, 0, NULL, '北京', '北京/北京市/东城区', '0395-8451274', '13725836914', '王玲', '邮箱测试2568877130', '安徽省', '河北省/石家庄市/长安区', '2568877130@163.com', '0395-8451274', '13629788553', '刘超', '2121020493750d0fd', 10);
INSERT INTO `express_mail_order` VALUES (26, '2022-02-04 17:30:04', '2022-02-04 17:30:32', '数码用品,', 1, 1, 0, NULL, '北京', '北京/北京市/东城区', '0395-8451274', '13725836914', '王玲', 'youxiang', '安徽省', '河北省/石家庄市/长安区', '2568877130@qq.com', '0395-8451274', '13629788553', '刘超', '202202040305257d4', 10);
INSERT INTO `express_mail_order` VALUES (27, '2022-02-04 18:08:15', '2022-02-04 18:15:14', '食品,', 1, 6, 0, NULL, '北京', '北京/北京市/东城区', '0395-8451274', '13725836914', '王玲', 'youxiang1', '安徽省', '河北省/石家庄市/长安区', '2568877130@qq.com', '0395-8451274', '13629788553', '刘超', '202202048074af3af', 10);
INSERT INTO `express_mail_order` VALUES (28, '2022-02-04 18:09:21', '2022-02-04 18:15:11', '生活用品', 45, 6, 0, NULL, '城关镇实务社区广陵散人公寓332号', '浙江省/漯河市/浦东新区', '', '18801470251', '华玲珑', '123', '安徽省', '河北省/石家庄市/长安区', '2568877130@qq.com', '0395-8451274', '13629788553', '刘超', '2022247940020020', 10);
INSERT INTO `express_mail_order` VALUES (29, '2021-08-23 15:58:18', '2021-08-23 15:58:18', '服饰,', 1, 0, 0, NULL, '南山区高新科技园北区', '广东省/广州市/越秀区', '010-86551123', '18383339998', '李四', '速度发货', '南山区高新科技园北区', '安徽省/安庆市/宿松县', 'super@163.com', '010-86551122', '18383339999', '张三', '2021082369446dcdb', 12);
COMMIT;

-- ----------------------------
-- Table structure for home_user
-- ----------------------------
DROP TABLE IF EXISTS `home_user`;
CREATE TABLE `home_user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `mobile` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `sex` int DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `status` int DEFAULT NULL,
  `detailed_address` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of home_user
-- ----------------------------
BEGIN;
INSERT INTO `home_user` VALUES (9, '2022-01-29 16:48:04', '2022-02-04 16:49:19', NULL, NULL, '15139710060', NULL, '123456', NULL, '1425675494@qq.com', 1, NULL);
INSERT INTO `home_user` VALUES (10, '2022-01-30 17:06:36', '2022-02-04 15:56:37', '安徽省/芜湖市/弋江区', '2022-01-26', '15313953166', '刘超', '123456', 1, '13523948375@163.com', 1, '安徽省/芜湖市/弋江区');
INSERT INTO `home_user` VALUES (12, '2022-02-04 16:32:45', '2022-02-04 16:32:45', NULL, NULL, '15313953167', NULL, '123456', NULL, '1568877131@qq.com', 1, NULL);
INSERT INTO `home_user` VALUES (13, '2021-08-23 20:34:42', '2021-08-23 20:34:42', NULL, NULL, '18386849119', NULL, '123456', NULL, 'superlkl0929@163.com', 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for home_user_address
-- ----------------------------
DROP TABLE IF EXISTS `home_user_address`;
CREATE TABLE `home_user_address` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `address` varchar(255) NOT NULL,
  `detailed_address` varchar(255) NOT NULL,
  `home_user_type` int DEFAULT NULL,
  `is_default` int DEFAULT NULL,
  `mobile` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `home_user_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK2k9c48p1y774fqojyp33d2kdf` (`home_user_id`),
  CONSTRAINT `FK2k9c48p1y774fqojyp33d2kdf` FOREIGN KEY (`home_user_id`) REFERENCES `home_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of home_user_address
-- ----------------------------
BEGIN;
INSERT INTO `home_user_address` VALUES (1, '2022-02-04 15:57:07', '2022-02-04 16:25:10', '河北省/石家庄市/长安区', '安徽省', 0, 0, '13629788553', '刘超', '0395-8451274', 10);
INSERT INTO `home_user_address` VALUES (2, '2022-02-04 15:57:57', '2022-02-04 15:57:57', '北京/北京市/东城区', '北京', 1, 0, '13725836914', '王玲', '0395-8451274', 10);
COMMIT;

-- ----------------------------
-- Table structure for home_user_id_card
-- ----------------------------
DROP TABLE IF EXISTS `home_user_id_card`;
CREATE TABLE `home_user_id_card` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `id_card` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `sex` int NOT NULL,
  `home_user_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKddhp7cjgcv4uwquao7tb8n53s` (`home_user_id`),
  CONSTRAINT `FKddhp7cjgcv4uwquao7tb8n53s` FOREIGN KEY (`home_user_id`) REFERENCES `home_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of home_user_id_card
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `name` varchar(18) NOT NULL,
  `url` varchar(128) DEFAULT NULL,
  `icon` varchar(32) DEFAULT NULL,
  `sort` int NOT NULL,
  `parent_id` bigint DEFAULT NULL,
  `is_bitton` bit(1) NOT NULL,
  `is_show` bit(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKsbtnjocfrq29e8taxdwo21gic` (`parent_id`),
  CONSTRAINT `FKsbtnjocfrq29e8taxdwo21gic` FOREIGN KEY (`parent_id`) REFERENCES `menu` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO `menu` VALUES (2, '2022-03-14 14:26:03', '2022-03-14 18:24:53', '系统设置', '', 'mdi-settings', 0, NULL, b'0', b'1');
INSERT INTO `menu` VALUES (3, '2022-03-14 16:58:55', '2022-03-14 18:26:02', '菜单管理', '/admin/menu/list', 'mdi-view-list', 1, 2, b'0', b'1');
INSERT INTO `menu` VALUES (5, '2022-03-14 17:04:44', '2022-03-14 18:27:53', '新增', '/admin/menu/add', 'mdi-plus', 2, 3, b'0', b'1');
INSERT INTO `menu` VALUES (7, '2022-03-14 17:07:43', '2022-03-15 12:11:25', '角色管理', '/admin/role/list', 'mdi-account-settings-variant', 5, 2, b'0', b'1');
INSERT INTO `menu` VALUES (8, '2022-03-14 18:28:48', '2022-03-21 22:04:45', '编辑', 'edit(\'/admin/menu/edit\')', 'mdi-grease-pencil', 3, 3, b'1', b'1');
INSERT INTO `menu` VALUES (9, '2022-03-14 18:30:00', '2022-03-21 22:08:20', '删除', 'del(\'/admin/menu/delete\')', 'mdi-close', 4, 3, b'1', b'1');
INSERT INTO `menu` VALUES (10, '2022-03-15 12:12:00', '2022-03-15 12:12:00', '添加', '/admin/role/add', 'mdi-account-plus', 6, 7, b'0', b'1');
INSERT INTO `menu` VALUES (11, '2022-03-15 12:12:36', '2022-03-21 22:10:45', '编辑', 'edit(\'/admin/role/edit\')', 'mdi-account-edit', 7, 7, b'1', b'1');
INSERT INTO `menu` VALUES (12, '2022-03-15 12:13:19', '2022-03-21 22:15:27', '删除', 'del(\'/admin/role/delete\')', 'mdi-account-remove', 8, 7, b'1', b'1');
INSERT INTO `menu` VALUES (13, '2022-03-15 12:14:52', '2022-01-20 16:05:51', '管理员管理', '/admin/user/list', 'mdi-account-multiple', 9, 2, b'0', b'1');
INSERT INTO `menu` VALUES (14, '2022-03-15 12:15:22', '2022-03-15 12:17:27', '添加', '/admin/user/add', 'mdi-account-plus', 10, 13, b'0', b'1');
INSERT INTO `menu` VALUES (15, '2022-03-16 17:18:14', '2022-03-21 22:11:19', '编辑', 'edit(\'/admin/user/edit\')', 'mdi-account-edit', 11, 13, b'1', b'1');
INSERT INTO `menu` VALUES (16, '2022-03-16 17:19:01', '2022-03-21 22:15:36', '删除', 'del(\'/admin/user/delete\')', 'mdi-account-remove', 12, 13, b'1', b'1');
INSERT INTO `menu` VALUES (19, '2022-03-22 11:24:36', '2022-03-22 11:26:00', '上传图片', '/upload/upload_photo', 'mdi-arrow-up-bold-circle', 0, 13, b'0', b'0');
INSERT INTO `menu` VALUES (20, '2022-03-22 14:09:35', '2022-03-22 14:09:47', '日志管理', '/system/operator_log_list', 'mdi-tag-multiple', 13, 2, b'0', b'1');
INSERT INTO `menu` VALUES (21, '2022-03-22 14:11:39', '2022-03-22 14:11:39', '删除', 'del(\'/system/delete_operator_log\')', 'mdi-tag-remove', 14, 20, b'1', b'1');
INSERT INTO `menu` VALUES (22, '2022-03-22 14:12:57', '2022-03-22 14:46:55', '清空日志', 'delAll(\'/system/delete_all_operator_log\')', 'mdi-delete-circle', 15, 20, b'1', b'1');
INSERT INTO `menu` VALUES (23, '2022-03-22 14:46:40', '2022-03-22 14:47:09', '数据备份', '/admin/database_bak/list', 'mdi-database', 16, 2, b'0', b'1');
INSERT INTO `menu` VALUES (24, '2022-03-22 14:48:07', '2022-03-22 15:13:41', '备份', 'add(\'/admin/database_bak/add\')', 'mdi-database-plus', 17, 23, b'1', b'1');
INSERT INTO `menu` VALUES (25, '2022-03-22 14:49:03', '2022-03-22 14:49:03', '删除', 'del(\'/admin/database_bak/delete\')', 'mdi-database-minus', 18, 23, b'1', b'1');
INSERT INTO `menu` VALUES (26, '2022-03-22 19:36:20', '2022-03-22 19:36:20', '还原', 'restore(\'/admin/database_bak/restore\')', 'mdi-database-minus', 19, 23, b'1', b'1');
INSERT INTO `menu` VALUES (28, '2022-01-18 13:38:47', '2022-01-28 17:45:55', '前台用户管理', '', 'mdi-buffer', 0, NULL, b'0', b'1');
INSERT INTO `menu` VALUES (29, '2022-01-18 13:39:06', '2022-01-27 14:50:41', '前台用户管理', '/admin/homeUser/list', 'mdi-cube-unfolded', 0, 28, b'0', b'1');
INSERT INTO `menu` VALUES (30, '2022-01-19 10:28:04', '2022-01-19 10:28:04', '网点管理', '', 'mdi-camera-metering-partial', 0, NULL, b'0', b'1');
INSERT INTO `menu` VALUES (31, '2022-01-19 10:28:32', '2022-01-19 10:28:32', '网点列表', '/admin/branches/list', 'mdi-cash', 0, 30, b'0', b'1');
INSERT INTO `menu` VALUES (33, '2022-01-19 10:29:16', '2022-01-19 10:29:16', '编辑', 'edit(\'/admin/branches/edit\')', 'mdi-checkbox-multiple-marked', 0, 31, b'1', b'1');
INSERT INTO `menu` VALUES (34, '2022-01-19 10:29:33', '2022-01-19 10:29:33', '删除', 'del(\'/admin/branches/delete\')', 'mdi-close-circle-outline', 0, 31, b'1', b'1');
INSERT INTO `menu` VALUES (35, '2022-01-19 10:29:53', '2022-01-19 10:29:53', '运输点管理', '', 'mdi-cellphone-link', 0, NULL, b'0', b'1');
INSERT INTO `menu` VALUES (36, '2022-01-19 10:30:28', '2022-01-19 10:30:28', '运输点列表', '/admin/transport/list', 'mdi-car-estate', 0, 35, b'0', b'1');
INSERT INTO `menu` VALUES (37, '2022-01-19 10:30:45', '2022-01-19 10:30:45', '添加', '/admin/transport/add', 'mdi-comment-plus-outline', 0, 36, b'0', b'1');
INSERT INTO `menu` VALUES (38, '2022-01-19 10:31:12', '2022-01-19 10:31:12', '编辑', 'edit(\'/admin/transport/edit\')', 'mdi-content-duplicate', 0, 36, b'1', b'1');
INSERT INTO `menu` VALUES (39, '2022-01-19 10:31:31', '2022-01-19 10:31:31', '删除', 'del(\'/admin/transport/delete\')', 'mdi-desktop-mac', 0, 36, b'1', b'1');
INSERT INTO `menu` VALUES (40, '2022-01-19 14:47:00', '2022-01-19 14:47:54', '快递管理', '', 'mdi-bus-double-decker', 31, NULL, b'0', b'1');
INSERT INTO `menu` VALUES (41, '2022-01-19 14:47:42', '2022-01-20 10:53:50', '揽收管理', '/admin/expressMailOrder/list', 'mdi-file-document-box', 32, 40, b'0', b'1');
INSERT INTO `menu` VALUES (42, '2022-01-19 15:34:15', '2022-01-20 11:22:41', '确认揽收', '/admin/expressMailOrder/takeDeliveryOfGoods', 'mdi-arrow-down-bold-circle', 0, 41, b'0', b'0');
INSERT INTO `menu` VALUES (43, '2022-01-19 15:42:29', '2022-01-20 10:47:35', '网点发货管理', '/admin/buyOff/list', 'mdi-ferry', 34, 40, b'0', b'1');
INSERT INTO `menu` VALUES (44, '2022-01-19 16:43:05', '2022-01-19 16:43:05', '发出货物', '/admin/expressMailOrder/sendTheCargo', 'mdi-arrow-down', 0, 43, b'0', b'0');
INSERT INTO `menu` VALUES (45, '2022-01-20 10:48:52', '2022-01-20 11:36:01', '中途收货管理', '/admin/processRecords/list', 'mdi-gas-station', 0, 40, b'0', b'1');
INSERT INTO `menu` VALUES (46, '2022-01-20 11:23:36', '2022-01-20 13:46:05', '确认收货并运输', '/admin/processRecords/takeDeliveryOfGoods', 'mdi-archive', 0, 45, b'0', b'0');
INSERT INTO `menu` VALUES (47, '2022-01-20 11:36:52', '2022-01-20 11:36:52', '中途运输管理', '/admin/processRecords/receiveList', 'mdi-android', 0, 40, b'0', b'1');
INSERT INTO `menu` VALUES (48, '2022-01-20 12:58:49', '2022-01-20 12:58:57', '继续运输', '/admin/processRecords/transportation', 'mdi-alert-octagon', 0, 47, b'0', b'0');
INSERT INTO `menu` VALUES (49, '2022-01-20 13:46:35', '2022-01-20 13:46:35', '确认收货并派送', '/admin/processRecords/delivery', 'mdi-apple-safari', 0, 45, b'0', b'0');
INSERT INTO `menu` VALUES (52, '2022-01-20 15:19:01', '2022-01-20 16:31:23', '指定派送管理', '/admin/buyOff/deliveryList', 'mdi-approval', 0, 40, b'0', b'1');
INSERT INTO `menu` VALUES (53, '2022-01-20 16:03:00', '2022-01-20 16:03:00', '快递员管理', '', 'mdi-emoticon', 0, NULL, b'0', b'1');
INSERT INTO `menu` VALUES (54, '2022-01-20 16:03:27', '2022-01-20 16:03:27', '快递员列表', '/admin/courier/list', 'mdi-format-align-justify', 0, 53, b'0', b'1');
INSERT INTO `menu` VALUES (55, '2022-01-20 16:03:52', '2022-01-20 16:03:52', '添加', '/admin/courier/add', 'mdi-loupe', 0, 54, b'0', b'1');
INSERT INTO `menu` VALUES (56, '2022-01-20 16:04:11', '2022-01-20 16:04:11', '编辑', 'edit(\'/admin/courier/edit\')', 'mdi-keyboard', 0, 54, b'1', b'1');
INSERT INTO `menu` VALUES (57, '2022-01-20 16:04:39', '2022-01-20 16:04:39', '删除', 'del(\'/admin/courier/delete\')', 'mdi-close-circle-outline', 0, 54, b'1', b'1');
INSERT INTO `menu` VALUES (58, '2022-01-20 16:22:41', '2022-01-20 16:22:41', '指定快递员', '/admin/buyOff/specifyTheDelivery', 'mdi-angularjs', 0, 52, b'0', b'0');
INSERT INTO `menu` VALUES (59, '2022-01-20 16:31:46', '2022-01-20 16:31:46', '派送管理', '/admin/buyOff/signForList', 'mdi-application', 0, 40, b'0', b'1');
INSERT INTO `menu` VALUES (60, '2022-01-20 17:48:59', '2022-01-20 17:49:09', '网点申请管理', '', 'mdi-check-all', 0, NULL, b'0', b'1');
INSERT INTO `menu` VALUES (61, '2022-01-20 17:49:40', '2022-01-20 17:49:40', '网点申请列表', '/admin/branchApplyFor/list', 'mdi-folder-multiple', 0, 60, b'0', b'1');
INSERT INTO `menu` VALUES (63, '2022-01-20 18:44:28', '2022-01-20 18:44:49', '编辑', 'edit(\'/admin/expressMailOrder/edit\')', 'mdi-arrange-bring-to-front', 0, 43, b'1', b'1');
INSERT INTO `menu` VALUES (64, '2022-01-25 15:21:45', '2022-02-03 09:16:45', '报价时效管理', '', 'mdi-alarm', 0, NULL, b'0', b'1');
INSERT INTO `menu` VALUES (65, '2022-01-25 15:22:29', '2022-01-25 15:22:50', '报价时效列表', '/admin/agingQuery/list', 'mdi-alarm-check', 0, 64, b'0', b'1');
INSERT INTO `menu` VALUES (66, '2022-01-25 15:23:24', '2022-01-25 15:23:24', '添加', '/admin/agingQuery/add', 'mdi-alarm-plus', 0, 65, b'0', b'1');
INSERT INTO `menu` VALUES (67, '2022-01-25 15:23:55', '2022-01-25 15:23:55', '删除', 'del(\'/admin/agingQuery/delete\')', 'mdi-alarm-off', 0, 65, b'1', b'1');
INSERT INTO `menu` VALUES (68, '2022-01-27 16:58:02', '2022-01-27 16:58:02', '编辑', 'edit(\'/admin/homeUser/edit\')', 'mdi-format-quote-close', 0, 29, b'1', b'1');
INSERT INTO `menu` VALUES (69, '2022-01-28 17:45:21', '2022-01-28 17:45:21', '投诉管理', '', 'mdi-gavel', 0, NULL, b'0', b'1');
INSERT INTO `menu` VALUES (70, '2022-01-28 17:45:45', '2022-01-28 17:45:45', '投诉列表', '/admin/complaint/list', 'mdi-face', 0, 69, b'0', b'1');
INSERT INTO `menu` VALUES (71, '2022-01-29 14:52:01', '2022-01-29 14:52:01', '上传图片', '/upload/upload_photo', 'mdi-angular', 0, 45, b'0', b'0');
INSERT INTO `menu` VALUES (72, '2022-01-29 14:52:58', '2022-01-29 14:52:58', '上传图片', '/upload/upload_photo', 'mdi-android-head', 0, 59, b'0', b'0');
INSERT INTO `menu` VALUES (73, '2021-08-01 16:22:17', '2021-08-15 16:22:26', '添加', 'add(\'/admin/branches/add\')', 'mdi-checkbox-multiple-marked', 0, 31, b'1', b'1');
INSERT INTO `menu` VALUES (74, '2021-08-28 18:47:51', '2021-08-28 18:47:54', '网点保存', '/admin/branches/applyFor', 'mdi-emoticon', 0, 2, b'0', b'0');
COMMIT;

-- ----------------------------
-- Table structure for operater_log
-- ----------------------------
DROP TABLE IF EXISTS `operater_log`;
CREATE TABLE `operater_log` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `content` varchar(128) NOT NULL,
  `operator` varchar(18) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of operater_log
-- ----------------------------
BEGIN;
INSERT INTO `operater_log` VALUES (1, '2022-02-04 16:01:46', '2022-02-04 16:01:46', '用户【广陵散人】于【2022-02-04 16:01:46】登录系统！', '广陵散人');
INSERT INTO `operater_log` VALUES (2, '2022-02-04 16:03:56', '2022-02-04 16:03:56', '编辑管理员，管理员名：测试账号', '广陵散人');
INSERT INTO `operater_log` VALUES (3, '2022-02-04 16:04:05', '2022-02-04 16:04:05', '编辑管理员，管理员名：测试账号', '广陵散人');
INSERT INTO `operater_log` VALUES (4, '2022-02-04 16:04:15', '2022-02-04 16:04:15', '编辑管理员，管理员名：测试账号', '广陵散人');
INSERT INTO `operater_log` VALUES (5, '2022-02-04 16:04:24', '2022-02-04 16:04:24', '编辑管理员，管理员名：小刘同志', '广陵散人');
INSERT INTO `operater_log` VALUES (6, '2022-02-04 16:04:29', '2022-02-04 16:04:29', '删除角色ID【2】', '广陵散人');
INSERT INTO `operater_log` VALUES (7, '2022-02-04 16:04:35', '2022-02-04 16:04:35', '删除角色ID【4】', '广陵散人');
INSERT INTO `operater_log` VALUES (8, '2022-02-04 16:06:26', '2022-02-04 16:06:26', '用户【合肥网点】于【2022-02-04 16:06:26】登录系统！', '合肥网点');
INSERT INTO `operater_log` VALUES (9, '2022-02-04 16:22:14', '2022-02-04 16:22:14', '用户【合肥网点】于【2022-02-04 16:22:14】登录系统！', '合肥网点');
INSERT INTO `operater_log` VALUES (10, '2022-02-04 16:24:42', '2022-02-04 16:24:42', '用户【广陵散人】于【2022-02-04 16:24:42】登录系统！', '广陵散人');
INSERT INTO `operater_log` VALUES (11, '2022-02-04 16:26:51', '2022-02-04 16:26:51', '用户【石家庄网点】于【2022-02-04 16:26:51】登录系统！', '石家庄网点');
INSERT INTO `operater_log` VALUES (12, '2022-02-04 16:36:19', '2022-02-04 16:36:19', '用户【合肥网点】于【2022-02-04 16:36:19】登录系统！', '合肥网点');
INSERT INTO `operater_log` VALUES (13, '2022-02-04 16:37:49', '2022-02-04 16:37:49', '用户【石家庄网点】于【2022-02-04 16:37:49】登录系统！', '石家庄网点');
INSERT INTO `operater_log` VALUES (14, '2022-02-04 16:38:24', '2022-02-04 16:38:24', '添加快递员，快递员名：王玲艳', '石家庄网点');
INSERT INTO `operater_log` VALUES (15, '2022-02-04 16:38:44', '2022-02-04 16:38:44', '添加快递员，快递员名：王龙', '石家庄网点');
INSERT INTO `operater_log` VALUES (16, '2022-02-04 16:39:11', '2022-02-04 16:39:11', '添加快递员，快递员名：王凯龙', '石家庄网点');
INSERT INTO `operater_log` VALUES (17, '2022-02-04 16:39:39', '2022-02-04 16:39:39', '添加快递员，快递员名：李龙', '石家庄网点');
INSERT INTO `operater_log` VALUES (18, '2022-02-04 16:42:50', '2022-02-04 16:42:50', '添加运输点，运输点名：广陵散人12', '广陵散人');
INSERT INTO `operater_log` VALUES (19, '2022-02-04 16:51:01', '2022-02-04 16:51:01', '编辑快递员，快递员名：王玲艳1', '石家庄网点');
INSERT INTO `operater_log` VALUES (20, '2022-02-04 16:51:16', '2022-02-04 16:51:16', '用户【王玲艳1】于【2022-02-04 16:51:16】登录系统！', '王玲艳1');
INSERT INTO `operater_log` VALUES (21, '2022-02-04 16:57:17', '2022-02-04 16:57:17', '用户【广陵散人】于【2022-02-04 16:57:17】登录系统！', '广陵散人');
INSERT INTO `operater_log` VALUES (22, '2022-02-04 16:57:47', '2022-02-04 16:57:47', '用户【合肥网点】于【2022-02-04 16:57:47】登录系统！', '合肥网点');
INSERT INTO `operater_log` VALUES (23, '2022-02-04 16:58:11', '2022-02-04 16:58:11', '用户【石家庄网点】于【2022-02-04 16:58:11】登录系统！', '石家庄网点');
INSERT INTO `operater_log` VALUES (24, '2022-02-04 16:58:19', '2022-02-04 16:58:19', '编辑快递员，快递员名：王玲艳', '石家庄网点');
INSERT INTO `operater_log` VALUES (25, '2022-02-04 17:30:24', '2022-02-04 17:30:24', '用户【石家庄网点】于【2022-02-04 17:30:24】登录系统！', '石家庄网点');
INSERT INTO `operater_log` VALUES (26, '2022-02-04 18:09:42', '2022-02-04 18:09:42', '用户【石家庄网点】于【2022-02-04 18:09:42】登录系统！', '石家庄网点');
INSERT INTO `operater_log` VALUES (27, '2022-02-04 18:13:04', '2022-02-04 18:13:04', '用户【重庆】于【2022-02-04 18:13:04】登录系统！', '重庆');
INSERT INTO `operater_log` VALUES (28, '2022-02-04 18:13:36', '2022-02-04 18:13:36', '添加快递员，快递员名：广陵散人123', '重庆');
INSERT INTO `operater_log` VALUES (29, '2022-02-04 18:14:07', '2022-02-04 18:14:07', '用户【广陵散人123】于【2022-02-04 18:14:07】登录系统！', '广陵散人123');
INSERT INTO `operater_log` VALUES (30, '2022-02-04 18:14:33', '2022-02-04 18:14:33', '用户【重庆】于【2022-02-04 18:14:33】登录系统！', '重庆');
INSERT INTO `operater_log` VALUES (31, '2022-02-04 18:15:03', '2022-02-04 18:15:03', '用户【广陵散人123】于【2022-02-04 18:15:03】登录系统！', '广陵散人123');
INSERT INTO `operater_log` VALUES (32, '2022-02-22 09:09:58', '2022-02-22 09:09:58', '用户【广陵散人】于【2022-02-22 09:09:58】登录系统！', '广陵散人');
INSERT INTO `operater_log` VALUES (33, '2021-08-23 16:08:42', '2021-08-23 16:08:42', '编辑快递员，快递员名：广陵散人666', 'admin');
INSERT INTO `operater_log` VALUES (34, '2021-08-23 16:59:46', '2021-08-23 16:59:46', '用户【admin】于【2021-08-23 16:59:45】登录系统！', 'admin');
INSERT INTO `operater_log` VALUES (35, '2021-08-23 21:14:39', '2021-08-23 21:14:39', '用户【admin】于【2021-08-23 21:14:38】登录系统！', 'admin');
INSERT INTO `operater_log` VALUES (36, '2021-08-23 21:15:53', '2021-08-23 21:15:53', '用户【北京网点】于【2021-08-23 21:15:53】登录系统！', '北京网点');
INSERT INTO `operater_log` VALUES (37, '2021-08-24 11:40:09', '2021-08-24 11:40:09', '用户【北京网点】于【2021-08-24 11:40:09】登录系统！', '北京网点');
INSERT INTO `operater_log` VALUES (38, '2021-08-24 11:42:02', '2021-08-24 11:42:02', '用户【北京网点】于【2021-08-24 11:42:01】登录系统！', '北京网点');
INSERT INTO `operater_log` VALUES (39, '2021-08-28 11:10:39', '2021-08-28 11:10:39', '用户【北京网点】于【2021-08-28 11:10:38】登录系统！', '北京网点');
INSERT INTO `operater_log` VALUES (40, '2021-08-28 11:36:21', '2021-08-28 11:36:21', '用户【北京网点】于【2021-08-28 11:36:20】登录系统！', '北京网点');
INSERT INTO `operater_log` VALUES (41, '2021-08-28 11:49:00', '2021-08-28 11:49:00', '用户【北京网点】于【2021-08-28 11:49:00】登录系统！', '北京网点');
INSERT INTO `operater_log` VALUES (42, '2021-08-28 14:27:13', '2021-08-28 14:27:13', '用户【北京网点】于【2021-08-28 14:27:12】登录系统！', '北京网点');
INSERT INTO `operater_log` VALUES (43, '2021-08-28 14:29:07', '2021-08-28 14:29:07', '用户【北京网点】于【2021-08-28 14:29:06】登录系统！', '北京网点');
INSERT INTO `operater_log` VALUES (44, '2021-08-28 15:19:48', '2021-08-28 15:19:48', '用户【北京网点】于【2021-08-28 15:19:48】登录系统！', '北京网点');
INSERT INTO `operater_log` VALUES (45, '2021-08-28 15:21:00', '2021-08-28 15:21:00', '用户【北京网点】于【2021-08-28 15:20:59】登录系统！', '北京网点');
INSERT INTO `operater_log` VALUES (46, '2021-08-28 15:38:21', '2021-08-28 15:38:21', '用户【北京网点】于【2021-08-28 15:38:20】登录系统！', '北京网点');
INSERT INTO `operater_log` VALUES (47, '2021-08-28 15:40:44', '2021-08-28 15:40:44', '用户【北京网点】于【2021-08-28 15:40:44】登录系统！', '北京网点');
INSERT INTO `operater_log` VALUES (48, '2021-08-28 15:43:07', '2021-08-28 15:43:07', '用户【admin】于【2021-08-28 15:43:07】登录系统！', 'admin');
INSERT INTO `operater_log` VALUES (49, '2021-08-28 15:44:05', '2021-08-28 15:44:05', '用户【北京网点】于【2021-08-28 15:44:05】登录系统！', '北京网点');
INSERT INTO `operater_log` VALUES (50, '2021-08-28 15:50:59', '2021-08-28 15:50:59', '用户【admin】于【2021-08-28 15:50:58】登录系统！', 'admin');
INSERT INTO `operater_log` VALUES (51, '2021-08-28 15:53:02', '2021-08-28 15:53:02', '用户【北京网点】于【2021-08-28 15:53:02】登录系统！', '北京网点');
INSERT INTO `operater_log` VALUES (52, '2021-08-28 15:54:15', '2021-08-28 15:54:15', '用户【弋江区运输点】于【2021-08-28 15:54:14】登录系统！', '弋江区运输点');
INSERT INTO `operater_log` VALUES (53, '2021-08-28 15:54:55', '2021-08-28 15:54:55', '用户【北京网点】于【2021-08-28 15:54:55】登录系统！', '北京网点');
INSERT INTO `operater_log` VALUES (54, '2021-08-28 15:59:38', '2021-08-28 15:59:38', '用户【北京网点】于【2021-08-28 15:59:37】登录系统！', '北京网点');
INSERT INTO `operater_log` VALUES (55, '2021-08-28 16:29:11', '2021-08-28 16:29:11', '用户【admin】于【2021-08-28 16:29:10】登录系统！', 'admin');
INSERT INTO `operater_log` VALUES (56, '2021-08-28 16:31:35', '2021-08-28 16:31:35', '用户【admin】于【2021-08-28 16:31:35】登录系统！', 'admin');
INSERT INTO `operater_log` VALUES (57, '2021-08-28 17:00:42', '2021-08-28 17:00:42', '用户【admin】于【2021-08-28 17:00:41】登录系统！', 'admin');
INSERT INTO `operater_log` VALUES (58, '2021-08-28 17:16:21', '2021-08-28 17:16:21', '用户【admin】于【2021-08-28 17:16:21】登录系统！', 'admin');
INSERT INTO `operater_log` VALUES (59, '2021-08-28 18:11:53', '2021-08-28 18:11:53', '用户【admin】于【2021-08-28 18:11:52】登录系统！', 'admin');
INSERT INTO `operater_log` VALUES (60, '2021-08-28 18:29:11', '2021-08-28 18:29:11', '用户【admin】于【2021-08-28 18:29:11】登录系统！', 'admin');
INSERT INTO `operater_log` VALUES (61, '2021-08-28 18:32:50', '2021-08-28 18:32:50', '用户【admin】于【2021-08-28 18:32:50】登录系统！', 'admin');
INSERT INTO `operater_log` VALUES (62, '2021-08-28 18:54:08', '2021-08-28 18:54:08', '用户【admin】于【2021-08-28 18:54:08】登录系统！', 'admin');
INSERT INTO `operater_log` VALUES (63, '2021-08-28 19:17:28', '2021-08-28 19:17:28', '用户【admin】于【2021-08-28 19:17:28】登录系统！', 'admin');
INSERT INTO `operater_log` VALUES (64, '2021-08-28 19:20:34', '2021-08-28 19:20:34', '用户【admin】于【2021-08-28 19:20:34】登录系统！', 'admin');
INSERT INTO `operater_log` VALUES (65, '2021-08-28 19:31:20', '2021-08-28 19:31:20', '用户【admin】于【2021-08-28 19:31:20】登录系统！', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for order_auth
-- ----------------------------
DROP TABLE IF EXISTS `order_auth`;
CREATE TABLE `order_auth` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `mac` varchar(32) DEFAULT NULL,
  `order_sn` varchar(18) NOT NULL,
  `phone` varchar(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of order_auth
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for process_records
-- ----------------------------
DROP TABLE IF EXISTS `process_records`;
CREATE TABLE `process_records` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `operation` int DEFAULT NULL,
  `travel_position` int DEFAULT NULL,
  `express_mail_order_id` bigint DEFAULT NULL,
  `next_branch_id` bigint DEFAULT NULL,
  `received_branch_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK885gaum7lsks1a34hosaovmv4` (`express_mail_order_id`),
  KEY `FKjobl0ywxlkbu727e05v3c2tek` (`next_branch_id`),
  KEY `FKdhcwfp4srflo7jq3p2aegigwf` (`received_branch_id`),
  CONSTRAINT `FK885gaum7lsks1a34hosaovmv4` FOREIGN KEY (`express_mail_order_id`) REFERENCES `express_mail_order` (`id`),
  CONSTRAINT `FKdhcwfp4srflo7jq3p2aegigwf` FOREIGN KEY (`received_branch_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FKjobl0ywxlkbu727e05v3c2tek` FOREIGN KEY (`next_branch_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of process_records
-- ----------------------------
BEGIN;
INSERT INTO `process_records` VALUES (1, '2022-02-04 16:36:39', '2022-02-04 16:49:43', 1, 3, 2, 39, 38);
INSERT INTO `process_records` VALUES (2, '2022-02-04 16:36:43', '2022-02-04 16:49:45', 1, 3, 1, 39, 38);
INSERT INTO `process_records` VALUES (3, '2022-02-04 16:36:49', '2022-02-04 16:49:54', 1, 3, 3, 39, 38);
INSERT INTO `process_records` VALUES (4, '2022-02-04 16:36:54', '2022-02-04 16:49:56', 1, 3, 4, 39, 38);
INSERT INTO `process_records` VALUES (5, '2022-02-04 16:37:00', '2022-02-04 16:49:49', 1, 3, 5, 39, 38);
INSERT INTO `process_records` VALUES (6, '2022-02-04 16:37:05', '2022-02-04 16:49:50', 1, 3, 6, 39, 38);
INSERT INTO `process_records` VALUES (7, '2022-02-04 16:59:30', '2022-02-04 16:59:30', 2, 4, 13, 31, 39);
INSERT INTO `process_records` VALUES (8, '2022-02-04 18:12:13', '2022-02-04 18:13:19', 1, 3, 27, 46, 39);
INSERT INTO `process_records` VALUES (9, '2022-02-04 18:12:16', '2022-02-04 18:13:17', 1, 3, 28, 46, 39);
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `name` varchar(18) NOT NULL,
  `remark` varchar(128) DEFAULT NULL,
  `status` int DEFAULT NULL,
  `role_type` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES (1, '2022-03-15 13:16:38', '2022-02-01 09:39:10', '超级管理员', '超级管理员拥有最高权限。', 1, 0);
INSERT INTO `role` VALUES (9, '2022-01-19 10:14:22', '2022-01-29 14:52:10', '网点', '', 1, 1);
INSERT INTO `role` VALUES (10, '2022-01-19 10:15:51', '2022-01-29 14:52:38', '运输点', '', 1, 2);
INSERT INTO `role` VALUES (11, '2022-01-20 16:08:52', '2022-01-30 18:23:47', '快递员', '', 1, 3);
COMMIT;

-- ----------------------------
-- Table structure for role_authorities
-- ----------------------------
DROP TABLE IF EXISTS `role_authorities`;
CREATE TABLE `role_authorities` (
  `role_id` bigint NOT NULL,
  `authorities_id` bigint NOT NULL,
  KEY `FKhj7ap1o1cjrl7enr9arf5f2qp` (`authorities_id`),
  KEY `FKg3xdaexmr0x1qx8omhvjtk46d` (`role_id`),
  CONSTRAINT `FKg3xdaexmr0x1qx8omhvjtk46d` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`),
  CONSTRAINT `FKhj7ap1o1cjrl7enr9arf5f2qp` FOREIGN KEY (`authorities_id`) REFERENCES `menu` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of role_authorities
-- ----------------------------
BEGIN;
INSERT INTO `role_authorities` VALUES (9, 40);
INSERT INTO `role_authorities` VALUES (9, 41);
INSERT INTO `role_authorities` VALUES (9, 42);
INSERT INTO `role_authorities` VALUES (9, 43);
INSERT INTO `role_authorities` VALUES (9, 44);
INSERT INTO `role_authorities` VALUES (9, 63);
INSERT INTO `role_authorities` VALUES (9, 45);
INSERT INTO `role_authorities` VALUES (9, 46);
INSERT INTO `role_authorities` VALUES (9, 49);
INSERT INTO `role_authorities` VALUES (9, 71);
INSERT INTO `role_authorities` VALUES (9, 47);
INSERT INTO `role_authorities` VALUES (9, 48);
INSERT INTO `role_authorities` VALUES (9, 52);
INSERT INTO `role_authorities` VALUES (9, 58);
INSERT INTO `role_authorities` VALUES (9, 53);
INSERT INTO `role_authorities` VALUES (9, 54);
INSERT INTO `role_authorities` VALUES (9, 55);
INSERT INTO `role_authorities` VALUES (9, 56);
INSERT INTO `role_authorities` VALUES (9, 57);
INSERT INTO `role_authorities` VALUES (10, 40);
INSERT INTO `role_authorities` VALUES (10, 45);
INSERT INTO `role_authorities` VALUES (10, 46);
INSERT INTO `role_authorities` VALUES (10, 71);
INSERT INTO `role_authorities` VALUES (10, 47);
INSERT INTO `role_authorities` VALUES (10, 48);
INSERT INTO `role_authorities` VALUES (11, 40);
INSERT INTO `role_authorities` VALUES (11, 59);
INSERT INTO `role_authorities` VALUES (11, 72);
INSERT INTO `role_authorities` VALUES (1, 2);
INSERT INTO `role_authorities` VALUES (1, 3);
INSERT INTO `role_authorities` VALUES (1, 5);
INSERT INTO `role_authorities` VALUES (1, 8);
INSERT INTO `role_authorities` VALUES (1, 9);
INSERT INTO `role_authorities` VALUES (1, 7);
INSERT INTO `role_authorities` VALUES (1, 10);
INSERT INTO `role_authorities` VALUES (1, 11);
INSERT INTO `role_authorities` VALUES (1, 12);
INSERT INTO `role_authorities` VALUES (1, 13);
INSERT INTO `role_authorities` VALUES (1, 14);
INSERT INTO `role_authorities` VALUES (1, 15);
INSERT INTO `role_authorities` VALUES (1, 16);
INSERT INTO `role_authorities` VALUES (1, 19);
INSERT INTO `role_authorities` VALUES (1, 20);
INSERT INTO `role_authorities` VALUES (1, 21);
INSERT INTO `role_authorities` VALUES (1, 22);
INSERT INTO `role_authorities` VALUES (1, 23);
INSERT INTO `role_authorities` VALUES (1, 24);
INSERT INTO `role_authorities` VALUES (1, 25);
INSERT INTO `role_authorities` VALUES (1, 26);
INSERT INTO `role_authorities` VALUES (1, 28);
INSERT INTO `role_authorities` VALUES (1, 29);
INSERT INTO `role_authorities` VALUES (1, 68);
INSERT INTO `role_authorities` VALUES (1, 30);
INSERT INTO `role_authorities` VALUES (1, 33);
INSERT INTO `role_authorities` VALUES (1, 35);
INSERT INTO `role_authorities` VALUES (1, 36);
INSERT INTO `role_authorities` VALUES (1, 37);
INSERT INTO `role_authorities` VALUES (1, 38);
INSERT INTO `role_authorities` VALUES (1, 39);
INSERT INTO `role_authorities` VALUES (1, 53);
INSERT INTO `role_authorities` VALUES (1, 54);
INSERT INTO `role_authorities` VALUES (1, 56);
INSERT INTO `role_authorities` VALUES (1, 57);
INSERT INTO `role_authorities` VALUES (1, 60);
INSERT INTO `role_authorities` VALUES (1, 61);
INSERT INTO `role_authorities` VALUES (1, 64);
INSERT INTO `role_authorities` VALUES (1, 65);
INSERT INTO `role_authorities` VALUES (1, 66);
INSERT INTO `role_authorities` VALUES (1, 67);
INSERT INTO `role_authorities` VALUES (1, 69);
INSERT INTO `role_authorities` VALUES (1, 70);
INSERT INTO `role_authorities` VALUES (1, 31);
INSERT INTO `role_authorities` VALUES (1, 34);
INSERT INTO `role_authorities` VALUES (1, 73);
INSERT INTO `role_authorities` VALUES (1, 74);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `head_pic` varchar(128) DEFAULT NULL,
  `mobile` varchar(12) DEFAULT NULL,
  `password` varchar(32) NOT NULL,
  `sex` int DEFAULT NULL,
  `status` int DEFAULT NULL,
  `username` varchar(18) NOT NULL,
  `role_id` bigint DEFAULT NULL,
  `user_type` int DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `branch_type` int DEFAULT NULL,
  `office_address` varchar(255) DEFAULT NULL,
  `id_card` varchar(255) DEFAULT NULL,
  `longitude_and_latitude` varchar(255) DEFAULT NULL,
  `branch_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_btsosjytrl4hu7fnm1intcpo8` (`username`),
  KEY `FKg09b8o67eu61st68rv6nk8npj` (`role_id`),
  CONSTRAINT `FKg09b8o67eu61st68rv6nk8npj` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, '2022-03-18 19:18:53', '2022-02-04 16:57:00', '20220204/1612429017873.jpg', '13356565656', '123456', 1, 1, 'admin', 1, 0, '北京/北京市/宣武区', NULL, NULL, '', '', NULL);
INSERT INTO `user` VALUES (2, '2022-03-18 19:20:36', '2022-02-04 16:04:05', '20220204/1612425843684.png', '13918655656', '123456', 1, 1, '测试账号', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (5, '2022-03-20 20:42:19', '2022-02-04 16:04:24', '20220323/1584956702094.png', '13356565656', '123456', 1, 1, '小刘同志', 1, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (31, '2022-01-29 14:46:55', '2022-02-04 11:25:02', NULL, '15303953066', '123456', 0, 1, '弋江区运输点', 10, 2, '安徽省/芜湖市/弋江区', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (32, '2022-01-29 14:47:10', '2022-02-04 11:25:12', NULL, '15303953066', '123456', 0, 1, '宣武区运输点', 10, 2, '北京/北京市/宣武区', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (33, '2022-01-29 14:49:53', '2022-01-29 14:49:53', NULL, '15303953066', '123456', 0, 1, '鸠江区运输点', 10, 2, '安徽省/芜湖市/鸠江区', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (38, '2022-02-04 16:02:15', '2021-08-28 17:30:32', NULL, '13629788553', '123456', 0, 0, '合肥网点', 9, 1, '安徽省/合肥市/包河区', 0, '117.348936,31.773212', '412725199809187845', '117.348936,31.773212', 1);
INSERT INTO `user` VALUES (39, '2022-02-04 16:24:47', '2022-02-04 16:24:47', NULL, '13629788553', '123456', 0, 1, '石家庄网点', 9, 1, '河北省/石家庄市/长安区', 1, '合肥', '412725199809187845', '121.586021,31.371322', NULL);
INSERT INTO `user` VALUES (40, '2022-02-04 16:38:24', '2022-02-04 16:58:19', NULL, '13561234512', '123456', 0, 1, '王玲艳', 11, 3, NULL, NULL, NULL, NULL, NULL, 39);
INSERT INTO `user` VALUES (41, '2022-02-04 16:38:44', '2022-02-04 16:38:44', NULL, '13612457823', '123456', 0, 1, '张三', 11, 3, NULL, NULL, NULL, NULL, NULL, 39);
INSERT INTO `user` VALUES (42, '2022-02-04 16:39:11', '2022-02-04 16:39:11', NULL, '13312567812', '123456', 0, 1, '王凯龙', 11, 3, NULL, NULL, NULL, NULL, NULL, 39);
INSERT INTO `user` VALUES (43, '2022-02-04 16:39:39', '2022-02-04 16:39:39', NULL, '13541234578', '123456', 0, 1, '李龙', 11, 3, NULL, NULL, NULL, NULL, NULL, 39);
INSERT INTO `user` VALUES (44, '2022-02-04 16:42:50', '2022-02-04 16:42:50', NULL, '13629788553', '123456', 0, 1, '广陵散人12', 10, 2, '安徽省/合肥市/瑶海区', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (45, '2022-02-04 16:44:15', '2022-02-04 16:44:15', NULL, '13629788553', '123456', 0, 1, '北京网点', 9, 1, '北京/北京市/东城区', 0, '北京', '412725199809187845', '116.664706,39.916927', NULL);
INSERT INTO `user` VALUES (46, '2022-02-04 16:45:07', '2022-02-04 16:45:07', NULL, '13629788553', '123456', 0, 1, '重庆', 9, 1, '重庆/重庆市/万州区', 0, '运输', '412725199809187845', '114.402395,38.103449', NULL);
INSERT INTO `user` VALUES (47, '2022-02-04 18:13:36', '2021-08-23 16:08:42', NULL, '13561241245', '123456', 0, 1, '广陵散人666', 11, 3, NULL, NULL, NULL, NULL, NULL, 46);
INSERT INTO `user` VALUES (48, '2021-08-28 16:07:05', '2021-08-28 16:07:05', NULL, '18386849119', '123456', 0, 1, '666', 9, 1, '北京/北京市/海淀区', 0, '紫金园', '522328199809291234', '116.35885,40.029063', NULL);
INSERT INTO `user` VALUES (49, '2021-08-28 19:37:35', '2021-08-28 19:37:35', NULL, '18386849119', '123456', 0, 1, '清清浅浅', 9, 1, '北京/北京市/石景山区', 0, '无误', '522328196903264124', '116.518677,39.978437', NULL);
INSERT INTO `user` VALUES (50, '2021-08-28 19:39:31', '2021-08-28 19:39:31', NULL, '18386849119', '123456', 0, 1, '请求', 9, 1, '安徽省/芜湖市/弋江区', 0, '啊啊啊', '522328196903264124', '116.518677,39.978437', NULL);
INSERT INTO `user` VALUES (51, '2021-08-28 19:44:16', '2021-08-28 19:44:16', NULL, '18386849119', '123456', 0, 1, '最牛', 9, 1, '安徽省/铜陵市/狮子山区', 0, '大师答', '522328196903264124', '116.518677,39.978437', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
